package com.ktjiaoyu.crm.mapper;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ktjiaoyu.crm.pojo.User;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface UserMapper extends BaseMapper<User> {

    User findUserById(@Param("usrId") Long usrId);

    @Select("select * from sys_user where usr_name like concat('%',#{usrName},'%')")
    User findUserByName(@Param("usrName") String usrName);

    //@Select("select * from sys_user ${ew.customSqlSegment}")
    List findUserByUsrId(@Param("ew") Wrapper wrapper);


}